You can have only one custom header and one custom footer on each worksheet. If you create a new custom header or footer, it replaces any other custom header or footer on the worksheet.
- Click the worksheet.
- On the View menu, click Header and Footer.
- To base a custom header or footer on an existing header or footer, click the header or footer in the Header or Footer box.
- Click Custom Header or Custom Footer.
- Click in the Left section, Center section, or Right section box, and then click the buttons to insert the header or footer information you want in that section.
- Do one or more of the following:
- To enter additional text for the header or footer, enter the text in the Left section, Center section, or Right section box.
-
To start a new line in one of the section boxes, press ENTER.
-
To delete a section of a header or footer, select the section that you want to delete in the section box, and then press BACKSPACE.
Notes
-
You can use the buttons in the Header or Footer dialog boxes to format or further customize your headers and footers.
-
Make sure the header or footer margin allows enough space for the custom header or footer.
Tips
- To include a single ampersand (&) within the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services.
- To start numbering pages with a number other than 1, specify the first page number, and then use &[Page] in the header or footer. To specify the first page number:
- On the File menu, click Page Setup.
- In the First page number box, type the first page number.